You are here: Main Menu > 1. Sales Menu > S. Setup > Importing Sales Reps

Importing Sales Reps

The Sales Rep table is available to be imported or exported as part of the system initialization process. Use this process to quickly build the tables in your system. The following fields are defined in this table. If a field is REQUIRED, it must be supplied as part of the import process.

Select Phase 2 - Sales Rep when importing/exporting Sales Rep type information.

Screen Label Type Alias Field Req Default Possible Values Table Alias
Sales Rep C 2 SalesRepId Yes
Old Id C 15 Old_Id
Name C 30 Name Yes
Contact C 30 Contact
Address 1 C 30 Address1
Address 2 C 30 Address2
City C 20 City
State C 2 State
Zip C 10 Zip
Phone C 14 Phone
Fax C 14 Fax
Commissions C 1 Commission N Y,N
Sales Order GP Calculation Method C 1 GpCalcMeth O O,A,S
Commission only on Collected Sales C 1 Collected Y Y,N
Exclude Accruals for Commissions C 1 Accruals N S,N,B,X
Commission Expense Account C 4 Account Account
Commission Expense Cost Center C 6 CostCenter Cost Center
User Id C 5 User User Security

Security Required : Tables - Other Tables

See Also Used In